QA/QC Module
## Relative path to the file: ./data/BBC_Example_Data_QC_Module.xlsx
## Warning: Expecting numeric in N2772 / R2772C14: got 'BDL'
## Warning: Expecting numeric in N2776 / R2776C14: got 'BDL'
## Warning: Expecting logical in AD7774 / R7774C30: got 'Here DO logger flipped
## upsidedown to minimize fouling by TW'
## # A tibble: 6 × 31
## Line_Num Stn_ID SAMP_DATE SAMP_DATE_TIME YEAR UniqueID GEN_QC
## <dbl> <chr> <dttm> <dttm> <dbl> <chr> <dbl>
## 1 1 SR4 2022-06-09 12:00:00 2022-06-09 12:00:00 2022 SR4_2022… 12
## 2 2 SR4 2022-06-09 12:15:00 2022-06-09 12:15:00 2022 SR4_2022… NA
## 3 3 SR4 2022-06-09 12:30:00 2022-06-09 12:30:00 2022 SR4_2022… NA
## 4 4 SR4 2022-06-09 12:45:00 2022-06-09 12:45:00 2022 SR4_2022… NA
## 5 5 SR4 2022-06-09 13:00:00 2022-06-09 13:00:00 2022 SR4_2022… NA
## 6 6 SR4 2022-06-09 13:15:00 2022-06-09 13:15:00 2022 SR4_2022… NA
## # ℹ 24 more variables: TIME <dttm>, Time_QC <lgl>, Temp_C_DOlogger <dbl>,
## # TEMP_QC_DOlogger <lgl>, Temp_C_condlogger <dbl>, TEMP_QC_condlogger <lgl>,
## # DO_mgl <dbl>, DO_QC <dbl>, DO_mgl_adj <dbl>, DO_adj_QC <dbl>,
## # DO_adj_QC_CALIBRATION <lgl>, `DO_% Sat` <dbl>, `DO%Sat_QC` <dbl>,
## # Sal_ppt <dbl>, Sal_QC <lgl>, Sal_QC_CALIBRATION <dbl>,
## # `High Range, μS/cm` <dbl>, HighRange_QC <lgl>, SpecCon <dbl>,
## # SpecCon_QC <lgl>, `Serial number_DOlogger` <dbl>, …
## # A tibble: 6 × 32
## Line_Num Stn_ID SAMP_DATE SAMP_DATE_TIME YEAR UniqueID GEN_QC
## <dbl> <chr> <dttm> <dttm> <dbl> <chr> <dbl>
## 1 1 SR4 2022-06-09 12:00:00 2022-06-09 12:00:00 2022 SR4_2022… 12
## 2 2 SR4 2022-06-09 12:15:00 2022-06-09 12:15:00 2022 SR4_2022… NA
## 3 3 SR4 2022-06-09 12:30:00 2022-06-09 12:30:00 2022 SR4_2022… NA
## 4 4 SR4 2022-06-09 12:45:00 2022-06-09 12:45:00 2022 SR4_2022… NA
## 5 5 SR4 2022-06-09 13:00:00 2022-06-09 13:00:00 2022 SR4_2022… NA
## 6 6 SR4 2022-06-09 13:15:00 2022-06-09 13:15:00 2022 SR4_2022… NA
## # ℹ 25 more variables: TIME <dttm>, Time_QC <lgl>, Temp_C_DOlogger <dbl>,
## # TEMP_QC_DOlogger <lgl>, Temp_C_condlogger <dbl>, TEMP_QC_condlogger <lgl>,
## # DO_mgl <dbl>, DO_QC <lgl>, DO_mgl_adj <dbl>, DO_adj_QC <dbl>,
## # DO_adj_QC_CALIBRATION <lgl>, `DO_% Sat` <dbl>, `DO%Sat_QC` <dbl>,
## # Sal_ppt <dbl>, Sal_QC <lgl>, Sal_QC_CALIBRATION <dbl>,
## # `High Range, μS/cm` <dbl>, HighRange_QC <lgl>, SpecCon <dbl>,
## # SpecCon_QC <lgl>, `Serial number_DOlogger` <dbl>, …
Salinity ranges used
## # A tibble: 6 × 37
## Line_Num Stn_ID SAMP_DATE SAMP_DATE_TIME YEAR UniqueID GEN_QC
## <dbl> <chr> <dttm> <dttm> <dbl> <chr> <dbl>
## 1 1 SR4 2022-06-09 12:00:00 2022-06-09 12:00:00 2022 SR4_2022… 12
## 2 2 SR4 2022-06-09 12:15:00 2022-06-09 12:15:00 2022 SR4_2022… NA
## 3 3 SR4 2022-06-09 12:30:00 2022-06-09 12:30:00 2022 SR4_2022… NA
## 4 4 SR4 2022-06-09 12:45:00 2022-06-09 12:45:00 2022 SR4_2022… NA
## 5 5 SR4 2022-06-09 13:00:00 2022-06-09 13:00:00 2022 SR4_2022… NA
## 6 6 SR4 2022-06-09 13:15:00 2022-06-09 13:15:00 2022 SR4_2022… NA
## # ℹ 30 more variables: TIME <dttm>, Time_QC <lgl>, Temp_C_DOlogger <dbl>,
## # TEMP_QC_DOlogger <lgl>, Temp_C_condlogger <dbl>, TEMP_QC_condlogger <lgl>,
## # DO_mgl <dbl>, DO_QC <lgl>, DO_mgl_adj <dbl>, DO_adj_QC <dbl>,
## # DO_adj_QC_CALIBRATION <lgl>, `DO_% Sat` <dbl>, `DO%Sat_QC` <dbl>,
## # Sal_ppt <dbl>, Sal_QC <lgl>, Sal_QC_CALIBRATION <dbl>,
## # `High Range, μS/cm` <dbl>, HighRange_QC <lgl>, SpecCon <dbl>,
## # SpecCon_QC <lgl>, `Serial number_DOlogger` <dbl>, …
Interactive Plots
## Warning in RColorBrewer::brewer.pal(N, "Set2"): minimal value for n is 3, returning requested palette with 3 different levels
## Warning in RColorBrewer::brewer.pal(N, "Set2"): minimal value for n is 3, returning requested palette with 3 different levels